﻿CREATE TABLE [trUser].[tblDriverSurroundings] (
    [IDDriverSurrounding]  BIGINT        IDENTITY (1, 1) NOT NULL,
    [IDCity]               BIGINT        NOT NULL,
    [IDState]              BIGINT        NOT NULL,
    [IDCounty]             BIGINT        NULL,
    [IDCountry]            BIGINT        NOT NULL,
    [CityLicenseNumber]    NVARCHAR (50) NULL,
    [StateLicenseNumber]   NVARCHAR (50) NULL,
    [CountyLicenseNumber]  NVARCHAR (50) NULL,
    [CountryLicenseNumber] NVARCHAR (50) NULL,
    [DateCreated]          DATETIME      CONSTRAINT [DF_tblDriverSurroundings_DateCreated] DEFAULT (getdate()) NULL,
    [DateUpdated]          DATETIME      NULL,
    [DateInactive]         DATETIME      NULL,
    CONSTRAINT [PK_tblDriverSurroundings] PRIMARY KEY CLUSTERED ([IDDriverSurrounding] ASC)
);

